package org.dashboard.constant;

public class DbMetaQueryConst {

    public static final String MYSQL_META_TABLES_QUERY = "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = SCHEMA()";
    public static final String MYSQL_META_COLUMNS_QUERY = "SELECT COLUMN_NAME,TABLE_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = SCHEMA()";

    public static final String POSTGRESQL_META_TABLES_QUERY = "SELECT TABLE_NAME FROM information_schema.TABLES where table_schema != ALL(array['pg_catalog','information_schema'])";
    public static final String POSTGRESQL_META_COLUMNS_QUERY = "SELECT COLUMN_NAME,TABLE_NAME FROM information_schema.COLUMNS where table_schema != ALL(array['pg_catalog','information_schema'])";

}
